//
//  SqliteHelper.h
//  Palabris
//
//  Created by vedat on 28.12.12.
//  Copyright (c) 2012 vedat. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>

@interface SqliteHelper : NSObject
{
    NSMutableArray *arrayOfWords;
    sqlite3 *databaseIPP;
    NSString *dbPathString;
}

- (void) createOrOpenDatabase;
- (void)addTableValue:(NSString*)value;
- (NSMutableArray*) getTableAllEntry;
- (NSMutableArray*) findKey:(NSString*)key;
- (int)getRowCount;
- (void)removeAllDataWithLength:(int)value;
- (int)getKeyCount:(NSString*)key;
- (BOOL)isKeyContainer:(NSString*)key;
- (void)printAllTable;
- (void)printKey:(NSString*)key;
- (void)removeAll;
- (void)closeDatabase;
- (void) readWords:(NSString*) fileName  fileType:(NSString*)fileType;
- (void) readWordsAndInsertTable:(NSString*) fileName  fileType:(NSString*)fileType;
- (void) readWordsAndInsertTable3:(NSString*) fileName  fileType:(NSString*)fileType;
@end
